Initial report on Object Spreadsheets
نویسندگان
چکیده
There is a growing demand for data-driven web applications that help automate organizational and business processes of low to medium complexity by letting users view and update structured data in controlled ways. We present Object Spreadsheets, an end-user development tool that combines a spreadsheet interface with a rich data model to help the process administrators build the logic for such applications themselves. Its all-in-one interface with immediate feedback has the potential to bring more complex tasks within reach of end-user developers, compared to existing approaches. Our data model is based on the structure of entity-relationship models and directly supports nested variable-size collections and object references, which are common in web applications but poorly accommodated by traditional spreadsheets. Object Spreadsheets has a formula language suited to the data model and supports stored procedures to specify the forms of updates that application users may make. Formulas can be used to assemble data in the exact structure in which it is to be shown in the application UI, simplifying the task of UI building; we intend for Object Spreadsheets to be integrated with a UI builder to provide a complete solution for application development. We describe our prototype implementation and several example applications we built to demonstrate the applicability of the tool. 1998 ACM Subject Classification D.1.6 Logic Programming; D.1.7 Visual Programming; H.2.1 Logical Design: Data models; H.2.3 Languages: Database (persistent) programming languages; H.2.3 Languages: Query languages; H.4.1 Office Automation: Spreadsheets
منابع مشابه
ClassSheets - model-based, object-oriented design of spreadsheet applications
Using spreadsheets is the preferred method to calculate, display or store anything that fits into a table-like structure. They are often used by end users to create applications. But they have one critical drawback-they are very error-prone. To reduce the error-proneness, we purpose a new way of object-oriented modeling of spreadsheets prior to using them. These spreadsheet models, termed Class...
متن کاملObject Spreadsheets : an end - user development tool for web applications backed by entity - relationship data ∗ Richard
There is a growing demand for data-driven web applications that help automate organizational and business processes of low to medium complexity by letting users view and update structured data in controlled ways. We present Object Spreadsheets, an end-user development tool that combines a spreadsheet interface with a rich data model to help the process administrators build the logic for such ap...
متن کاملMODFLOW 2001 and Other Modeling Odysseys Proceedings, 2001, International Ground Water Modeling Center, Colorado School of Mines, Golden, CO, p. 815-822 The Power of Spreadsheet Models
Prior to using MODFLOW, students need experience with simpler codes that provide “hands-on” experience setting up boundary and initial conditions, coding simple solution algorithms, and handling numerical errors. The best way to do this is using spreadsheet models; faculty no longer can expect students to know a common computer language, but students are familiar with spreadsheets. Many aspects...
متن کاملHow to turn spreadsheets into object oriented models
It is very common to see engineers using spreadsheets (e.g. excel) as a small database. For instance, a data dictionary will be a spreadsheet with a column for the data identifier and then different columns for data attributes (e.g. data type, step, min and max value). An advanced use would be to add two columns for functions producing and consuming the data resulting in a cross-reference dicti...
متن کاملSystematic evolution of model-based spreadsheet applications
Using spreadsheets is the preferred method to calculate, display or store anything that fits into a table-like structure. They are often used by end users to create applications, although they have one critical drawback—spreadsheets are very error-prone. Recent research has developed methods to reduce this error-proneness by introducing a new way of object-oriented modeling of spreadsheets befo...
متن کامل